home *** CD-ROM | disk | FTP | other *** search
/ Personal Computer World 2009 February / PCWFEB09.iso / Software / Resources / Developer & Web Development Tools / Twistpad 1.64 / Setup.exe / $APPDATA / Carthago / Twistpad / Syntax / Sql2000.sdf < prev    next >
Text File  |  2007-04-07  |  6KB  |  105 lines
  1. ;Microsoft Transact-SQL Syntax highlight Script for Twistpad
  2. ;1998 - 2007 ⌐ Carthago Software
  3.  
  4. [::Header::]
  5. SyntaxName=Microsoft Transact-SQL
  6. Extensions=sql
  7. Functions=(?i)sElect*
  8. Spelling=0 
  9. SpellingContexts=1;2
  10. CommentChar=--
  11.  
  12. [Comment1]
  13. Type=StartStop
  14. Context=1
  15. Priority=10
  16. Scope=0
  17. WholeWordOnly=0
  18. First=--
  19. Last=
  20. Background=Default
  21. Foreground=008000
  22.  
  23. [Comment2]
  24. Type=StartStop
  25. Context=2
  26. Scope=0
  27. Priority=10
  28. WholeWordOnly=0
  29. First=/*
  30. Last=*/
  31. Background=Default
  32. Foreground=008000
  33. Outline=1
  34.  
  35. [Quote]
  36. Type=StartStop
  37. Context=4
  38. Scope=0
  39. Priority=10
  40. WholeWordOnly=0
  41. First='
  42. Last='
  43. Background=Default
  44. Foreground=FF0000
  45.  
  46. [Operators]
  47. Type=keyword
  48. Context=101
  49. Scope=0
  50. Priority=6
  51. WholeWordOnly=1
  52. Keyword1=ALL;AND;ANY;BETWEEN;CROSS;EXISTS;IN;JOIN;LIKE;NOT;NULL;OR;OUTER;SOME
  53. Keyword2=
  54. Keyword3=
  55. Keyword4=
  56. Keyword5=
  57. Keyword6=
  58. Keyword7=
  59. Keyword8=
  60. Keyword9=
  61. Keyword10=
  62. Keyword11=
  63. Keyword12=
  64. Keyword13=
  65. Keyword14=
  66. Keyword15=
  67. Keyword16=
  68. Background=Default
  69. Foreground=808080
  70.  
  71. [SQL Keywords]
  72. Type=keyword
  73. Context=102
  74. Scope=0
  75. Priority=6
  76. WholeWordOnly=1
  77. Keyword1=ABSOLUTE;ACTION;ADD;AFTER;ALTER;ANSI_DEFAULTS;ANSI_NULLS;ANSI_NULL_DFLT_OFF;ANSI_NULL_DFLT_ON;ANSI_PADDING;ANSI_WARNINGS;APPEND;ARITHABORT;ARITHIGNORE;AS;ASC;AT;AUTHORIZATION;AUTO;BACKUP;BASE64;BEGIN;BLOCKSIZE;BREAK;BROWSE;BULK;BY;CASCADE;CHECK
  78. Keyword2=CHECKALLOC;CHECKCATALOG;CHECKDB;CHECKFILEGROUP;CHECKIDENT;CHECKPOINT;CHECKTABLE;CLOSE;CLUSTERED;COLLATE;COLUMN;COLUMNS;COMMIT;COMMITTED;COMPUTE;CONCAT;CONCAT_NULL_YIELDS_NULL;CONFIRM;CONNECT;CONNECTION;CONSTRAINT;CONTAINS;CONTAINSTABLE;CONTEXT_INFO;CONTINUE
  79. Keyword3=CONTROLROW;CREATE;CUBE;CURRENT;CURRENT_DATE;CURRENT_TIME;CURSOR;CURSOR_CLOSE_ON_COMMIT;DATABASE;DATE;DATEFORMAT;DBCC;DBREPAIR;DEADLOCK_PRIORITY;DEALLOCATE;DECLARE;DEFAULT;DELAY;DELETE;DENY;DESC;DESCRIPTION;DIFFERENTIAL;DISABLE_DEF_CNST_CHK;DISK;DISTINCT;DISTRIBUTED;DOUBLE;DROP;DROP_EXISTING;DUMMY
  80. Keyword4=DUMP;DYNAMIC;ELEMENTS;ELSE;ENCRYPTION;END;ERRLVL;ERROREXIT;ESCAPE;EXCEPT;EXEC;EXECUTE;EXIT;EXPIREDATE;EXPLICIT;FALSE;FAST;FASTFIRSTROW;FAST_FORWARD;FETCH;FILE;FILEGROUP;FILEGROWTH;FILELISTONLY;FILENAME;FILLFACTOR;FIPS_FLAGGER;FIRST;FLOPPY;FMTONLY;FOR;FORCE;FORCEPLAN;FOREIGN;FORMAT;FORWARD_ONLY;FREE
  81. Keyword5=FREETEXT;FREETEXTTABLE;FROM;FULL;FULLSCAN;FUNCTION;FUNCTIONS;GLOBAL;GOTO;GRANT;GROUP;GROUPING;HASH;HASH;HAVING;HEADERONLY;HELP;HOLDLOCK;HOUR;IDENTITYCOL;IDENTITY_INSERT;IF;IGNORE_DUP_KEY;IMPLICIT_TRANSACTIONS;INDEX;INIT;INNER;INPUTBUFFER;INSENSITIVE;INSERT;INSTEAD;INTERSECT;INTO;IO;IS;ISOLATION;KEEP;KEY;KEYSET;KILL;LABELONLY;LAST
  82. Keyword6=LEVEL;LINENO;LOAD;LOCAL;LOOP;MAX;MAXDOP;MAXSIZE;MEDIADESCRIPTION;MEDIANAME;MEDIAPASSWORD;MERGE;MIN;MINUTE;MIRROREXIT;MODIFY;MOVE;MSLOGREADER_HISTORY;NAME;NATIONAL;NEWALLOC;NEXT;NO;NOCHECK;NOCOUNT;NOEXEC;NOFORMAT;NOINIT;NOLOCK;NONCLUSTERED;NORECOMPUTE;NORECOVERY;NOREWIND;NOSKIP;NOUNLOAD;NO_LOG;NO_TRUNCATE;NUMERIC_ROUNDABORT;OF;OFF;OFFSETS
  83. Keyword7=ON;ONCE;ONLY;OPEN;OPENDATASOURCE;OPENQUERY;OPENROWSET;OPENTRAN;OPENXML;OPTIMISTIC;OPTION;ORDER;OUT;OUTPUT;OUTPUTBUFFER;OVER;PAD_INDEX;PAGLOCK;PARSEONLY;PARTIAL;PASSWORD;PERCENT;PERM;PERMANENT;PINTABLE;PIPE;PLAN;PRECISION;PREPARE;PRIMARY;PRINT;PRIOR;PRIVILEGES;PROC;PROCCACHE;PROCEDURE;PROCESSEXIT;PROFILE;PUBLIC;QUERY_GOVERNOR_COST_LIMIT;QUOTED_IDENTIFIER;RAISERROR;RAW;READ
  84. Keyword8=READCOMMITTED;READPAST;READTEXT;READUNCOMMITTED;READ_ONLY;RECOMPILE;RECONFIGURE;RECOVERY;REFERENCES;RELATIVE;REMOTE_PROC_TRANSACTIONS;REMOVE;REPEATABLE;REPEATABLEREAD;REPLICATION;RESTART;RESTORE;RESTRICT;RESTRICTED_USER;RETAINDAYS;RETURN;RETURNS;REVOKE;REWIND;ROBUST;ROLLBACK;ROLLUP;ROWGUIDCOL;ROWLOCK;ROWS;ROWVERSION;RULE;SAMPLE;SAVE;SCHEMA;SCHEMABINDING;SCROLL;SCROLL;SCROLL_LOCKS;SECOND
  85. Keyword9=SECTION;SELECT;SEQUENCE;SERIALIZABLE;SET;SETUSER;SHOWCONTIG;SHOWPLAN_ALL;SHOWPLAN_TEXT;SHOW_STATISTICS;SHRINKDATABASE;SHRINKFILE;SHUTDOWN;SIZE;SKIP;SQLPERF;STANDBY;STATIC;STATISTICS;STATISTICS_NORECOMPUTE;STATS;STOPAT;STOPATMARK;STOPBEFOREMARK;TABLE;TABLOCK;TABLOCKX;TAPE;TEMP;TEMPORARY;TEXTIMAGE_ON;THEN;TIME;TO;TOP;TRACEOFF;TRACEON;TRACESTATUS;TRAN;TRANSACTION;TRANSLATION;TRIGGER;TRUE;TRUNCATE;TRUNCATE_ONLY
  86. Keyword10=TSEQUAL;TYPE_WARNING;UNCOMMITTED;UNION;UNIQUE;UNLOAD;UNPINTABLE;UPDATE;UPDATETEXT;UPDATEUSAGE;UPDLOCK;USE;USEROPTIONS;VALUES;VARYING;VERIFYONLY;VIEW;VIEWS;VIEW_METADATA;WAITFOR;WHEN;WHERE;WHILE;WITH;WORK;WRITETEXT;XACT_ABORT;XML
  87. Keyword11=XMLDATA;BIGINT;BINARY;BIT;CHAR;CHARACTER;DATETIME;DEC;DECIMAL;FLOAT;IMAGE;INT;INTEGER;MONEY;NCHAR;NTEXT;NUMERIC;NVARCHAR;REAL;SMALLDATETIME;SMALLINT;SMALLMONEY;SQL_VARIANT;TEXT;TIMESTAMP;TINYINT;UNIQUEIDENTIFIER;VARBINARY;VARCHAR;GO
  88. Background=Default
  89. Foreground=0000FF
  90.  
  91.  
  92. [Functions]
  93. Type=keyword
  94. Context=103
  95. Scope=0
  96. Priority=6
  97. WholeWordOnly=1
  98. Keyword1=@@CONNECTIONS;@@CPU_BUSY;@@CURSOR_ROWS;@@DATEFIRST;@@DBTS;@@ERROR;@@FETCH_STATUS;@@IDENTITY;@@IDLE;@@IO_BUSY;@@LANGID;@@LANGUAGE;@@LOCK_TIMEOUT;@@MAX_CONNECTION;@@MAX_PRECISION;@@NESTLEVEL;@@OPTIONS;@@PACKET_ERRORS;@@PACK_RECEIVED;@@PACK_SENT;@@PROCID;@@REMSERVER;@@ROWCOUNT;@@SERVERNAME;@@SERVICENAME;@@SPID;@@TEXTSIZE;@@TIMETICKS;@@TOTAL_ERRORS
  99. Keyword2=@@TOTAL_READ;@@TOTAL_WRITE;@@TRANCOUNT;@@VERSION;ABS;ACOS;APP_NAME;ASCII;ASIN;ATAN;ATN2;AVG;BINARY_CHECKSUM;CASE;CAST;CEILING;CHARINDEX;CHECKSUM;CHECKSUM_AGG;COALESCE;COLLATIONPROPERT;COLUMNPROPERTY;COL_LENGTH;COL_NAME;CONVERT;COS;COT;COUNT;COUNT_BIG;CURRENT_TIMESTAM;CURRENT_USER;CURSOR_STATUS;DATABASEPROPERTY;DATABASEPROPERTY;DATALENGTH;DATEADD;DATEDIFF;DATENAME;DATEPART;DAY;DB_ID
  100. Keyword3=DB_NAME;DEGREES;DIFFERENCE;EXP;FILEGROUPPROPERT;FILEGROUP_ID;FILEGROUP_NAME;FILEPROPERTY;FILE_ID;FILE_NAME;FLOOR;FORMATMESSAGE;FULLTEXTCATALOGP;FULLTEXTSERVICEP;GETANSINULL;GETDATE;GETUTCDATE;HOST_ID;HOST_NAME;IDENTITY;IDENT_CURRENT;IDENT_INCR;IDENT_SEED;INDEXKEY_PROPERT;INDEXPROPERTY;INDEX_COL;ISDATE;ISNULL;ISNUMERIC;IS_MEMBER;IS_SRVROLEMEMBER;LEFT;LEN;LOG;LOG10;LOWER;LTRIM;MONTH;NEWID
  101. Keyword4=NULLIF;OBJECTPROPERTY;OBJECT_ID;OBJECT_NAME;PARSENAME;PATINDEX;PATINDEX;PERMISSIONS;PI;POWER;QUOTENAME;RADIANS;RAND;REPLACE;REPLICATE;REVERSE;RIGHT;ROUND;RTRIM;SCOPE_IDENTITY;SERVERPROPERTY;SESSIONPROPERTY;SESSION_USER;SIGN;SIN;SOUNDEX;SPACE;SQL_VARIANT_PROP;SQRT;SQUARE;STATS_DATE;STDEV;STDEVP;STR;STUFF;SUBSTRING;SUM;SUSER_ID;SUSER_NAME;SUSER_SID;SUSER_SNAME;SYSTEM_USER;TAN;TEXTPTR;TEXTVALID;TYPEPROPERTY;UNICODE
  102. Keyword5=UPPER;USER;USER;USER_ID;USER_NAME;VAR;VARP;YEAR
  103. Background=Default
  104. Foreground=FF00FF
  105.